<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>

<head>
	<title>Luxena dbExpress driver for Informix Pro manual</title>

	<meta name="Owner" content="Luxena Software Company">
	<meta name="Robots" content="ALL">
	<meta name="Copyright" content="Copyright (c) 2001-2006 Luxena Software Company">
	<meta name="Language" content="English">
	<meta http-equiv="Content-Type" content="text/html">

	<link href="styles/general.css" rel=stylesheet type="text/css">

	<base target="_blank">
</head>

<body>

	<table class="body_text" width="100%" border="0" cellpadding="1" cellspacing="0">

		<tr>
			<td class="page_caption">Connection string feature</td>
			<td align="right" valign="top"><a class="index" href="../index.htm">index</a></td>
		</tr>

		<tr><td colspan="2" height="10"></td></tr>

		<tr><td colspan="2">
			Connection string feature is a method of configuring dbExpress driver for Informix Pro.
			Physically connection string feature is a "HostName" parameter that exists in
			TSQLConnection.Params collection. Connection string is a semicolon separated collection
			of name-value pairs.
		</td></tr>
	
		<tr><td colspan="2" height="5"></td></tr>
	
		<tr><td colspan="2">
			Runtime connection string feature utilizing example:
		</td></tr>

		<tr><td colspan="2" class="code_spacing">
			<tt>SQLConnection.Params.Values['HostName'] := 'InformixServer=server;
			Client_Locale=en_us.8859-1; Fet_Buf_Size=32767; OptOFC=1; AutoCommit=True; BlobSize=-1;
			WaitOnLocks=False; CommitRetain=False; IsolationLevel=ReadCommitted; Trim Char=False;
			money=currency; decimal=bcd; int8=fmtbcd; lvarchar=string';</tt>
		</td></tr>

		<tr><td colspan="2" height="15"></td></tr>

		<tr><td colspan="2" class="block_caption">Why connection string is useful?</td></tr>

		<tr><td colspan="2" height="10"></td></tr>

		<tr><td colspan="2">
			Connection string allows developers <i><b>flexible configure driver parameters</b></i>,
			including all setnet32 parameters and peculiar driver's parameters that affects performance,
			transaction management, etc. and are not available through standard dbExpress configuration.
		</td></tr>

		<tr><td colspan="2" height="5"></td></tr>

		<tr><td colspan="2">
			<i><b>Avoids configuration constraints</b></i> that are common to standard dbExpress
			configuration by TSQLConnection.Params. For example, it is possible to force driver to
			trim chars in Delphi 6, where Trim Char configuration parameter is absent in dbExpress
			configuration.
		</td></tr>

		<tr><td colspan="2" height="5"></td></tr>
		
		<tr><td colspan="2">
			With connection string developers are able to specify all Informix Connect parameters
			needed for connection without configuring Informix connectivity software. This feature
			makes the <i><b>deploying of applications</b></i> much easier allowing install the
			Informix Client without need to configure it.
		</td></tr>

		<tr><td colspan="2" height="40"></td></tr>

		<tr><td colspan="2" class="block_caption">
			Standard to connection string parameters mapping
		</td></tr>

		<tr><td colspan="2" height="10"></td></tr>
		
		<tr><td colspan="2">
			For backward compatibility dbExpress driver for Informix Pro supports standard dbExpress
			configuration parameters that are available in TSQLConnection.Params collection. 
		</td></tr>
		
		<tr><td colspan="2" height="10"></td></tr>
	
		<tr><td colspan="2">
			<table width="100%" cellspacing=1>
				<thead class="table_header">
					<tr height="28">
						<td width="50%">dbExpress configuration parameter</td>
						<td width="50%">driver Pro connection string parameter</td>
					</tr>
				</thead>
				<tbody class="table_text">
					<tr>
						<td class="table_name_odd">SERVERCHARSET</td>
						<td class="table_desc_odd">CLIENT_LOCALE</td>
					</tr>
					<tr> 
						<td class="table_name_even">HOSTNAME</td>
						<td class="table_desc_even">INFORMIXSERVER</td>
					</tr>
					<tr> 
						<td class="table_name_odd">AUTOCOMMIT</td>
						<td class="table_desc_odd">AUTOCOMMIT</td>
					</tr>
					<tr> 
						<td class="table_name_even">BLOBSIZE</td>
						<td class="table_desc_even">BLOBSIZE</td>
					</tr>
					<tr> 
						<td class="table_name_odd">WAITONLOCKS</td>
						<td class="table_desc_odd">WAITONLOCKS</td>
					</tr>
					<tr> 
						<td class="table_name_even">COMMITRETAIN</td>
						<td class="table_desc_even">COMMITRETAIN</td>
					</tr>
					<tr> 
						<td class="table_name_odd">INFORMIXLUXENA TRANSISOLATION</td>
						<td class="table_desc_odd">ISOLATIONLEVEL</td>
					</tr>
					<tr> 
						<td class="table_name_even">TRIM CHAR</td>
						<td class="table_desc_even">TRIM CHAR</td>
					</tr>
				</tbody>
			</table>
		</td></tr>

		<tr><td colspan="2" height="5"></td></tr>

		<tr><td colspan="2" class="hint">
			<img src="images/info_point.gif" border="0" align="absMiddle">&nbsp;standard
			dbExpress configuration	parameters have higher priority against connection string parameters.
		</td></tr>

		<tr><td colspan="2" height="40"></td></tr>

		<tr><td colspan="2" class="block_caption">
			Connection string parameters description
		</td></tr>

		<tr><td colspan="2" height="20"></td></tr>	

		<tr><td colspan="2">
			Connection string may contain parameter of two kinds:
		</td></tr>
		<tr><td colspan="2" height="3"></td></tr>	
		<tr><td colspan="2">
			1) Custom parameters of dbExpress driver for Informix Pro;<br>
			2) Informix connectivity environment variables. Majority of which are available by means of setnet32 utility.<br>
		</td></tr>

		<tr><td colspan="2" height="20"></td></tr>

		<tr><td colspan="2">
			<table width="100%" cellspacing=1>
				<caption class="table_caption">Custom parameters of dbExpress driver for Informix Pro</caption>
				<thead class="table_header">
					<tr height="28"> 
						<td width="20%">parameter</td>
						<td width="50%">purpose</td>
						<td width="30%">possible values</td>
					</tr>
				</thead>
				<tbody class="table_text">
					<tr>
						<td class="table_name_odd">AUTOCOMMIT</td>
						<td class="table_desc_odd">
						specifies an action, commit(true) or rollback(false), that have to be executed if
						there is an active transaction on disconnect.<br>
						also, for ansi database specifies whether the connection should commit transaction after 
						every statement execution.
						</td>
						<td class="table_desc_odd">true or false.<br>Default is true.</td>
					</tr>
					<tr>
						<td class="table_name_even">BLOBSIZE</td>
						<td class="table_desc_even">specifies the number of kilobytes of BLOB data that is fetched for BLOB fields</td>
						<td class="table_desc_even">if BLOBSIZE = -1 then fetch data size calculated automatically otherwise it
						specifies maximum size of fetched data.<br>Default is -1.</td>
					</tr>
					<tr>
						<td class="table_name_odd">COMMITRETAIN</td>
						<td class="table_desc_odd">specifies cursor behaviour when a commit or rollback transaction is called.</td>
						<td class="table_desc_odd">true (close cursor) or false (preserve cursor).<br>Default is true.</td>
					</tr>
					<tr>
						<td class="table_name_even">DECIMAL</td>
						<td class="table_desc_even">mapping of Informix data type to VCL data type</td>
						<td class="table_desc_even">Float, Currency, Bcd or FmtBcd.<br>Default is Bcd.</td>
					</tr>
					<tr>
						<td class="table_name_odd">INT8</td>
						<td class="table_desc_odd">mapping of Informix data type to VCL data type</td>
						<td class="table_desc_odd">Float, Currency, Bcd or FmtBcd.<br>Default is FmtBcd.</td>
					</tr>
					<tr>
						<td class="table_name_even">ISOLATIONLEVEL</td>
						<td class="table_desc_even">defines the degree of concurrency among processes that attempt to access the same rows simultaneously</td>
						<td class="table_desc_even">DIRTYREAD, CURSORSTABILITY, REPEATABLEREAD or READCOMMITTED.<br>Default is READCOMMITTED</td>
					</tr>
					<tr>
						<td class="table_name_odd">LVARCHAR</td>
						<td class="table_desc_odd">mapping of Informix data type to VCL data type</td>
						<td class="table_desc_odd">Blob or String.<br>Default is String.</td>
					</tr>
					<tr>
						<td class="table_name_even">MONEY</td>
						<td class="table_desc_even">mapping of Informix data type to VCL data type</td>
						<td class="table_desc_even">Float, Currency, Bcd or FmtBcd.<br>Default is Currency.</td>
					</tr>
					<tr>
						<td class="table_name_odd">TRIM CHAR</td>
						<td class="table_desc_odd">trims trailing spaces from a data CHAR type</td>
						<td class="table_desc_odd">true or false.<br>Default is false.</td>
					</tr>
					<tr>
						<td class="table_name_even">WAITONLOCKS</td>
						<td class="table_desc_even">defines how the database server handles a process that tries 
						to access a locked row or table.</td>
						<td class="table_desc_even">true (infinitly wait), false (not wait) or number of seconds to wait.<br>Default is false.</td>
					</tr>
					<tr>
						<td class="table_name_odd">THREAD MODE</td>
						<td class="table_desc_odd">defines usage mode in threads.
							Informix connectivity allows only one active connection per thread, so if more than
							one connection are used in thread or connection is used in several threads, application
							must switch active connection for an execution thread.
						</td>
						<td class="table_desc_odd">ONE PER THREAD, MANY PER THREAD, INTERTHREADED (FETCH OPTIMIZED) and INTERTHREADED.<br>Default is INTERTHREADED (FETCH OPTIMIZED).</td>
					</tr>
				</tbody>
			</table>
		</td></tr>

		<tr><td colspan="2" height="5"></td></tr>

		<tr><td colspan="2" class="hint">
			<img src="images/info_point.gif" border="0" align="absMiddle">
			&nbsp;all connection string parameters' values are <b>case insensitive</b>.
		</td></tr>

		<tr><td colspan="2" height="15"></td></tr>

		<tr><td colspan="2">
			<b>Informix connectivity environment variables</b>
		</td></tr>

		<tr><td colspan="2" height="5"></td></tr>	
		
		<tr><td colspan="2">
			Informix Client SDK, Version 2.5, supports the following environment variables. For
			more information on these environment variables, see their descriptions in
			the respective Informix manuals.<br>
			<i>IBM Informix Client Products Installation Guide</i> which contains 
			following environments variables available <a href="http://publib.boulder.ibm.com/epubs/pdf/6638a.pdf">here</a>.
		</td></tr>

		<tr><td colspan="2" height="5"></td></tr>

		<tr><td colspan="2">
			<table width="100%" cellspacing=1>
				<thead class="table_header">
					<tr height="28">
						<td width="20%">parameter</td>
						<td width="55%">purpose</td>
						<td width="25%">possible values</td>
					</tr>
				</thead>
				<tbody class="table_text">
					<tr><td class="table_name_odd">CC8BITLEVEL</td>	<td class="table_desc_odd">Specifies how the C-language compiler processes non-ASCII (8-bit and multibyte) characters.</td>	<td class="table_desc_odd">Default is 2.</td></tr>
					<tr><td class="table_name_even">CLIENT_LOCALE</td>	<td class="table_desc_even">Specifies the locale that the client application uses to perform read/write operations that involve the keyboard, display, file, or printer on the client computer.</td>	<td class="table_desc_even">Any valid locale specifier. No default.</td></tr>
					<tr><td class="table_name_odd">COLLCHAR</td>	<td class="table_desc_odd">Specifies a collation sequence for characters. Provided for backward compatibility with NLS products.</td>	<td class="table_desc_odd"></td></tr>
					<tr><td class="table_name_even">DB_LOCALE</td>	<td class="table_desc_even">Specifies the locale of all the databases that a client application accesses in a single connection (the database locale).</td>	<td class="table_desc_even"></td></tr>
					<tr><td class="table_name_odd">DBALSBC</td>	<td class="table_desc_odd">When set to 1, enables compatibility with ALS products.</td>	<td class="table_desc_odd">Values: 0 or 1.</td></tr>
					<tr><td class="table_name_even">DBANSIWARN</td>	<td class="table_desc_even">When turned on (y), causes the preprocessor to check for Informix extensions to ANSI-standard SQL syntax at compile time and causes an application to check for Informix extensions at runtime.</td>	<td class="table_desc_even">Default is n.</td></tr>
					<tr><td class="table_name_odd">DBAPICODE</td>	<td class="table_desc_odd">Enables pre-7.2 systems that use nonstandard or rare code sets to access databases that store data in a standard code set. Maximum size = 23 characters. Provided for backward compatibility with NLS and ALS products.</td>	<td class="table_desc_odd"></td></tr>
					<tr><td class="table_name_even">DBASCIIBC</td>	<td class="table_desc_even">When set to 1, enables compatibility with ASCII products.</td>	<td class="table_desc_even">Values: 0 or 1.</td></tr>
					<tr><td class="table_name_odd">DBCENTURY</td>	<td class="table_desc_odd">Specifies how to expand values of two-digit-year DATE and DATETIME values. P = past century, R = present century, C = closest century.</td>	<td class="table_desc_odd">Values: P, R, or C Default is R.</td></tr>
					<tr><td class="table_name_even">DBCODESET</td>	<td class="table_desc_even">Specifies an Asian-locale code set. Overrides the code set that DB_LOCALE specifies. Provided for backward compatibility with Version 4.x and 5. ALS products.</td>	<td class="table_desc_even">Same values as ALS DBAPICODE. Default is 8859-1: (unless the informix.rc file specifies another system-wide default)</td></tr>
					<tr><td class="table_name_odd">DBCONNECT</td>	<td class="table_desc_odd">Specifies whether or not connections are restricted.</td>	<td class="table_desc_odd">Values: 1 or 3</td></tr>
					<tr><td class="table_name_even">DBCSCONV</td>	<td class="table_desc_even">Controls code-set conversion initialization. Maximum size is eight characters. Provided for backward compatibility with ALS products.</td>	<td class="table_desc_even">Values: 1 or 2:codesetname. See 5.0 ALS documentation.</td></tr>
					<tr><td class="table_name_odd">DBCSOVERRIDE</td>	<td class="table_desc_odd">Forces the user-specified DB_LOCALE value to override default restrictions on accessing databases with locales different from DB_LOCALE. Provided for backward compatibility with Version 6.0 ALS database servers.</td>	<td class="table_desc_odd">Values: 0 or 1.</td></tr>
					<tr><td class="table_name_even">DBCSWIDTH</td>	<td class="table_desc_even">Maximum number of display bytes (1-2) and storage bytes (1-4) for the characters in up to three code sets. Display and storage widths are separated by commas; code sets are separated by colons. Maximum size of this field is, therefore, 11 characters. Provided for backward compatibility with ALS products.</td>	<td class="table_desc_even">Example: 1,1:2,3 means a display and storage width of 1 byte for character set 1; a display width of 2 bytes and a storage width of 3 bytes for code set 2.</td></tr>
					<tr><td class="table_name_odd">DBDATE</td>	<td class="table_desc_odd">Specifies the end-user format for DATE values so that they can conform with various international date conventions. Provided for backward compatibility with pre-7.2 products. Informix recommends GL_DATE for 7.2 ESQL/C applications.</td>	<td class="table_desc_odd">Default is MDY4 unless NLS variable LC_TIME is activated.</td></tr>
					<tr><td class="table_name_even">DBFLTMASK</td>	<td class="table_desc_even">Specifies the number of decimal digits to use when storing a DECIMAL, SMALLFLOAT, or FLOAT data type in a character buffer.</td>	<td class="table_desc_even">Values: 0-16. Default is 16.</td></tr>
					<tr><td class="table_name_odd">DBLANG</td>	<td class="table_desc_odd">Specifies the subdirectory of the Informix installation directory that contains the product-specific message (.iem) files.</td>	<td class="table_desc_odd">Default is \msg.</td></tr>
					<tr><td class="table_name_even">DBMONEY</td>	<td class="table_desc_even">Specifies the end-user format for MONEY values so that they can conform with various international and local monetary conventions.</td>	<td class="table_desc_even">Default is $.,.</td></tr>
					<tr><td class="table_name_odd">DBMONEYSCALE</td>	<td class="table_desc_odd">Specifies the total number of digits and number of decimal digits for monetary values. Provided for backward compatibility with ALS products.</td>	<td class="table_desc_odd"></td></tr>
					<tr><td class="table_name_even">DBNLS</td>	<td class="table_desc_even">Specifies whether an application can access NLS features. Provided for backward compatibility with NLS products.</td>	<td class="table_desc_even">Default is n.</td></tr>
					<tr><td class="table_name_odd">DBPATH</td>	<td class="table_desc_odd">Identifies the database servers that contain databases that the application accesses.</td>	<td class="table_desc_odd"></td></tr>
					<tr><td class="table_name_even">DBSS2</td>	<td class="table_desc_even">Maximum size is four characters. Provided for backward compatibility with ALS products.</td>	<td class="table_desc_even">Values: 0x00-0xff or 0-255</td></tr>
					<tr><td class="table_name_odd">DBSS3</td>	<td class="table_desc_odd">Maximum size is four characters. Provided for backward compatibility with ALS products.</td>	<td class="table_desc_odd">Values: 0x00-0xff or 0-255</td></tr>
					<tr><td class="table_name_even">DBTEMP</td>	<td class="table_desc_even">Specifies the directory on the client computer that the client processor uses to store temporary files (also called swap files).</td>	<td class="table_desc_even">Default is \tmp.</td></tr>
					<tr><td class="table_name_odd">DBTIME</td>	<td class="table_desc_odd">Specifies the end-user format for DATETIME values so that they can conform with various international date conventions. Informix recommends GL_DATETIME for 7.2 ESQL/C applications. Provided for backward compatibility with pre-7.2 products.</td>	<td class="table_desc_odd">Default is %Y-%m-%d %H:%M:%S.</td></tr>
					<tr><td class="table_name_even">DELIMIDENT</td>	<td class="table_desc_even">Indicates whether (y) or not (n) to interpret strings in double quotes as delimited identifiers.</td>	<td class="table_desc_even">Default is n.</td></tr>
					<tr><td class="table_name_odd">ESQLMF</td>	<td class="table_desc_odd">Indicates whether the ESQL/C processor automatically invokes the ESQL/C multibyte filter (value=1 and CC8BITLEVEL<3, or not value=0).</td>	<td class="table_desc_odd"></td></tr>
					<tr><td class="table_name_even">FET_BUF_SIZE</td>	<td class="table_desc_even">Overrides the default size of the fetch buffer.</td>	<td class="table_desc_even">Any valid buffer size, in bytes. Default value depends on row size.</td></tr>
					<tr><td class="table_name_odd">GL_DATE</td>	<td class="table_desc_odd">Specifies a customized end-user format for DATE values.</td>	<td class="table_desc_odd"></td></tr>
					<tr><td class="table_name_even">GL_DATETIME</td>	<td class="table_desc_even">Specifies a customized end-user format for DATETIME values.</td>	<td class="table_desc_even"></td></tr>
					<tr><td class="table_name_odd">IFX_NOZEROMDY</td>	<td class="table_desc_odd"></td>	<td class="table_desc_odd"></td></tr>
					<tr><td class="table_name_even">IFX-USE_PREC_16</td>	<td class="table_desc_even"></td>	<td class="table_desc_even"></td></tr>
					<tr><td class="table_name_odd">INFORMIXCONRETRY</td>	<td class="table_desc_odd">Specifies the maximum number of additional connection attempts made to a database server in the time limit that CONTIME specifies.</td>	<td class="table_desc_odd">Default is 1.</td></tr>
					<tr><td class="table_name_even">INFORMIXCONTIME</td>	<td class="table_desc_even">Specifies the number of seconds an SQL CONNECT statement continues to try to establish a connection before it generates an error.</td>	<td class="table_desc_even">Default is 15.</td></tr>
					<tr><td class="table_name_odd">INFORMIXDIR</td>	<td class="table_desc_odd">Identifies the location of the client programs, library files, message files, header files, and other Informix software components.</td>	<td class="table_desc_odd">Default is C:\INFORMIX.</td></tr>
					<tr><td class="table_name_even">INFORMIXSERVER</td>	<td class="table_desc_even">Identifies the default database server.</td>	<td class="table_desc_even"></td></tr>
					<tr><td class="table_name_odd">INFORMIXSQLHOSTS</td>	<td class="table_desc_odd">Specifies the name of the computer on which the central registry resides.</td>	<td class="table_desc_odd"></td></tr>
					<tr><td class="table_name_even">LANG</td>	<td class="table_desc_even">Specifies the language environment (called a locale) for an NLS database that an application accesses. Provided for backward compatibility with NLS products.</td>	<td class="table_desc_even">Default is C.</td></tr>
					<tr><td class="table_name_odd">LC_COLLATE</td>	<td class="table_desc_odd">Specifies a collation or sort sequence for data in NCHAR and NVARCHAR columns of an NLS database. Provided for backward compatibility with NLS products.</td>	<td class="table_desc_odd">Default is the value that LANG specifies.</td></tr>
					<tr><td class="table_name_even">LC_CTYPE</td>	<td class="table_desc_even">Specifies character attributes such as character classification and case conversion of regular expressions for data in NCHAR and NVARCHAR columns of an NLS database. Provided for backward compatibility with NLS products.</td>	<td class="table_desc_even">Default is the value that LANG specifies.</td></tr>
					<tr><td class="table_name_odd">LC_MONETARY</td>	<td class="table_desc_odd">Specifies the end-user format for MONEY values in an NLS database. Provided for backward compatibility with NLS products.</td>	<td class="table_desc_odd">Default is the value that LANG specifies.</td></tr>
					<tr><td class="table_name_even">LC_NUMERIC</td>	<td class="table_desc_even">Specifies the end-user format for numeric values in an NLS database. Provided for backward compatibility with NLS products.</td>	<td class="table_desc_even">Default is the value that LANG specifies.</td></tr>
					<tr><td class="table_name_odd">LC_TIME</td>	<td class="table_desc_odd">Specifies the end-user format for DATE and DATETIME values in an NLS database. Provided for backward compatibility with NLS products.</td>	<td class="table_desc_odd">Default is the value that LANG specifies.</td></tr>
					<tr><td class="table_name_even">NODEFDAC</td>	<td class="table_desc_even">Allows default table privileges for PUBLIC when a new table is created in a database that is not ANSI compliant.</td>	<td class="table_desc_even">Default is to allow privileges.</td></tr>
					<tr><td class="table_name_odd">OPTMSG</td>	<td class="table_desc_odd">Enables optimized message transfers (message chaining) for all SQL statements in an application.</td>	<td class="table_desc_odd">Default is the value that LANG specifies.</td></tr>
					<tr><td class="table_name_even">OPTOFC</td>	<td class="table_desc_even">Enables optimize-OPEN-FETCH-CLOSE functionality in an Informix ESQL/C application that uses DECLARE and OPEN statements to execute a cursor.</td>	<td class="table_desc_even">Default is the value that LANG specifies.</td></tr>
					<tr><td class="table_name_odd">USE_DTENV</td>	<td class="table_desc_odd">Enables support for non-ANSI datetime formats in ESQL/C client programs.</td>	<td class="table_desc_odd"></td></tr>
				</tbody>
			</table>
		</td></tr>

		<tr><td colspan="2" height="15"></td></tr>

		<tr><td colspan="2">
			<b>Informix connectivity environment variables for Microsoft Windows</b>
		</td></tr>

		<tr><td colspan="2" height="5"></td></tr>

		<tr><td colspan="2">
			Following parameters affects only windows installations of Informix connectivity.
			Although, this parameters are present in setnet32 without "win32" prefix using of them
			on windows platform is valid only with "win32" followed by parameter name without any
			separating character. For example, WIN32SERVICE stands for SERVICE parameter.
		</td></tr>

		<tr><td colspan="2" height="5"></td></tr>

		<tr><td colspan="2">
			<table width="100%" cellspacing=1>
				<thead class="table_header">
					<tr height="28">
						<td width="20%">parameter</td>
						<td width="50%">purpose</td>
						<td width="30%">possible values</td>
					</tr>
				</thead>
				<tbody class="table_text">
					<tr> 
						<td class="table_name_odd">WIN32PROTOCOL</td>
						<td class="table_desc_odd">identifies which Network Protocol should be used</td>
						<td class="table_desc_odd">olsoctcp, onsoctcp, olsocspx, onsocspx, sesoctcp, sesocspx, seipcpip or olipcnmp</td>
					</tr>
					<tr> 
						<td class="table_name_even">WIN32SERVICE</td>
						<td class="table_desc_even">the ServiceName that the remote database server uses to listen to all incoming requests</td>
						<td class="table_desc_even"></td>
					</tr>
					<tr> 
						<td class="table_name_odd">WIN32USER</td>
						<td class="table_desc_odd">
						Informix login user name
						</td>
						<td class="table_desc_odd"></td>
					</tr>
					<tr> 
						<td class="table_name_even">WIN32PASS</td>
						<td class="table_desc_even">Informix login user password</td>
						<td class="table_desc_even"></td>
					</tr>
					<tr> 
						<td class="table_name_odd">WIN32OPTIONS</td>
						<td class="table_desc_odd">
						defines options specific to the database server. Refer to Server Administrator's Guide for more information.
						</td>
						<td class="table_desc_odd"></td>
					</tr>
					<tr> 
						<td class="table_name_even">WIN32HOST</td>
						<td class="table_desc_even">
							the name of the host machine where Informix server resides</td>
						<td class="table_desc_even"></td>
					</tr>
					<tr> 
						<td class="table_name_odd">WIN32ASKPASSWORD</td>
						<td class="table_desc_odd">specifies whether your application is to prompt for password at the time of connection
						to a server, has no password or you provide password by means of WIN32PASS environment variable</td>
						<td class="table_desc_odd">
						y (ask password at runtime), n (no password) or p (password)</td>
					</tr>
				</tbody>
			</table>
		</td></tr>
	</table>
</body>

</html>
